l106/opdracht les leerlingen/leerlingendetails.php
<?php
if($_GET['llnr']){
$llnr = $_GET['llnr'];
include('../newdb.php');
$queryLeerlingen ="select *
from leerlingen a
where llnr = $llnr
order by a.llnr";
$resultLeerlingen = mysqli_query($db, $queryLeerlingen) or die(mysqli_error($db));
$row = mysqli_fetch_array($resultLeerlingen);
echo "<p>$row[klas] $row[plaats] </p>\n";
$queryUitleningen ="select *
from uitleningen u, boeken b
where llnr = $llnr and u.boeknr = b.boeknr
order by datum_uit";
$resultUitleningen = mysqli_query($db , $queryUitleningen) or die(mysqli_error($db));
echo "<p>";
while($rowUitleningen = mysqli_fetch_array($resultUitleningen)){
echo "<div>$rowUitleningen[titel] $rowUitleningen[datum_uit]</div>";
}
echo "</p>";
}
?>
Resultaat
Made by Thijs Aarnoudse